fairnesscoop /
permacoop
| Total Complexity | 2 |
| Total Lines | 25 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
| 1 | import { MigrationInterface, QueryRunner } from 'typeorm'; |
||
| 2 | |||
| 3 | export class AddUserAdministrativeWorkingTime1637158054129 |
||
| 4 | implements MigrationInterface { |
||
| 5 | name = 'AddUserAdministrativeWorkingTime1637158054129'; |
||
| 6 | |||
| 7 | public async up(queryRunner: QueryRunner): Promise<void> { |
||
| 8 | await queryRunner.query( |
||
| 9 | `CREATE TYPE "user_administrative_workingtime_enum" AS ENUM('full_time', 'part_time')` |
||
| 10 | ); |
||
| 11 | await queryRunner.query( |
||
| 12 | `ALTER TABLE "user_administrative" ADD "workingTime" "user_administrative_workingtime_enum"` |
||
| 13 | ); |
||
| 14 | await queryRunner.query( |
||
| 15 | `UPDATE "user_administrative" SET "workingTime" = 'full_time'` |
||
| 16 | ); |
||
| 17 | await queryRunner.query( |
||
| 18 | `ALTER TABLE "user_administrative" ALTER "workingTime" SET NOT NULL` |
||
| 19 | ); |
||
| 20 | } |
||
| 21 | |||
| 22 | public async down(queryRunner: QueryRunner): Promise<void> { |
||
| 23 | await queryRunner.query( |
||
| 24 | `ALTER TABLE "user_administrative" DROP COLUMN "workingTime"` |
||
| 25 | ); |
||
| 26 | await queryRunner.query(`DROP TYPE "user_administrative_workingtime_enum"`); |
||
| 27 | } |
||
| 29 |
